400 |
How can I display the column using currency format and enlarge the font for certain values
Dim oComboBox as P Dim var_Column as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex var_Column = oComboBox.Columns.Add("Currency") ' var_Column.Def(17) = 1 oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.Def(17) = 1" var_Column.FormatColumn = "len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)" var_Items = oComboBox.Items var_Items.AddItem("1.23") var_Items.AddItem("2.34") var_Items.AddItem("9.94") var_Items.AddItem("11.94") var_Items.AddItem("1000") |
399 |
How can I get the number of occurrences of a specified string in the cell
Dim h as N Dim oComboBox as P Dim var_Column as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("") var_Column = oComboBox.Columns.Add("occurrences") var_Column.ComputedField = "lower(%0) count 'o'" var_Column.FormatColumn = "'contains ' + value + ' of \'o\' chars'" var_Items = oComboBox.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1 oooof the root") var_Items.InsertItem(h,,"Child 2") var_Items.InsertItem(h,,"Child 3") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
398 |
How can I display dates in my format
Dim oComboBox as P Dim var_Column as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex var_Column = oComboBox.Columns.Add("Date") ' var_Column.Def(17) = 1 oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.Def(17) = 1" var_Column.FormatColumn = "'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'" var_Items = oComboBox.Items var_Items.AddItem({01/21/2001}) var_Items.AddItem({02/22/2002}) var_Items.AddItem({03/13/2003}) var_Items.AddItem({04/24/2004}) |
397 |
How can I display dates in short format
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.Columns.Add("Date").FormatColumn = "shortdate(value)" var_Column = oComboBox.Columns.Add("Date") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.FormatColumn = `shortdate(value)`" var_Items = oComboBox.Items var_Items.AddItem({01/01/2001}) var_Items.AddItem({02/02/2002}) var_Items.AddItem({03/03/2003}) var_Items.AddItem({04/04/2004}) |
396 |
How can I display dates in long format
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.Columns.Add("Date").FormatColumn = "longdate(value)" var_Column = oComboBox.Columns.Add("Date") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.FormatColumn = `longdate(value)`" var_Items = oComboBox.Items var_Items.AddItem({01/01/2001}) var_Items.AddItem({02/02/2002}) var_Items.AddItem({03/03/2003}) var_Items.AddItem({04/04/2004}) |
395 |
How can I display only the right part of the cell
Dim h as N Dim oComboBox as P Dim var_Column as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("") var_Column = oComboBox.Columns.Add("Right") var_Column.ComputedField = "%0 right 2" var_Column.FormatColumn = "'\"' + value + '\"'" var_Items = oComboBox.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.InsertItem(h,,"SChild 3") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
394 |
How can I display only the left part of the cell
Dim h as N Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("") ' oComboBox.Columns.Add("Left").ComputedField = "%0 left 2" var_Column = oComboBox.Columns.Add("Left") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `%0 left 2`" var_Items = oComboBox.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.InsertItem(h,,"SChild 3") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
393 |
How can I display true or false instead 0 and -1
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.Columns.Add("Boolean").FormatColumn = "value != 0 ? 'true' : 'false'" var_Column = oComboBox.Columns.Add("Boolean") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.FormatColumn = `value != 0 ? 'true' : 'false'`" var_Items = oComboBox.Items var_Items.AddItem(.t.) var_Items.AddItem(.f.) var_Items.AddItem(.t.) var_Items.AddItem(0) var_Items.AddItem(1) |
392 |
How can I display icons or images instead numbers
Dim oComboBox as P Dim var_Column as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") var_Column = oComboBox.Columns.Add("Icons") ' var_Column.Def(17) = 1 oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.Def(17) = 1" var_Column.FormatColumn = "'The cell displays the icon <img>'+value+'</img> instead ' + value" var_Items = oComboBox.Items var_Items.AddItem(1) var_Items.AddItem(2) var_Items.AddItem(3) |
391 |
How can I display the column using currency
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.Columns.Add("Currency").FormatColumn = "currency(dbl(value))" var_Column = oComboBox.Columns.Add("Currency") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.FormatColumn = `currency(dbl(value))`" var_Items = oComboBox.Items var_Items.AddItem("1.23") var_Items.AddItem("2.34") var_Items.AddItem("0") var_Items.AddItem(5) var_Items.AddItem("10000.99") |
390 |
How can I display the currency only for not empty cells
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Number") ' oComboBox.Columns.Add("Currency").ComputedField = "len(%0) ? currency(dbl(%0)) : ''" var_Column = oComboBox.Columns.Add("Currency") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `len(%0) ? currency(dbl(%0)) : ''`" var_Items = oComboBox.Items var_Items.AddItem("1.23") var_Items.AddItem("2.34") var_Items.AddItem("0") ' var_Items.ItemBackColor(var_Items.AddItem()) = 8421631 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.ItemBackColor(AddItem()) = 8421631" var_Items.AddItem("10000.99") |
389 |
Is there a function to display the number of days between two date including the number of hours
Dim h as N Dim oComboBox as P Dim var_Column as local Dim var_Column1 as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.Columns.Add("Start").Width = 32 var_Column = oComboBox.Columns.Add("Start") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.Width = 32" oComboBox.Columns.Add("End") ' oComboBox.Columns.Add("Duration").ComputedField = "2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '' : str(=:1) + ' day(s)') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? ' and ' : '') + =:3 + ' hour(s)' : '' )" var_Column1 = oComboBox.Columns.Add("Duration") oComboBox.TemplateDef = "dim var_Column1" oComboBox.TemplateDef = var_Column1 oComboBox.Template = "var_Column1.ComputedField = `2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '' : str(=:1) + ' day(s)') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? ' and ' : '') + =:3 + ' hour(s)' : '' )`" var_Items = oComboBox.Items h = var_Items.AddItem({01/11/2001}) ' var_Items.CellCaption(h,1) = {01/14/2001} oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = #1/14/2001#" h = var_Items.AddItem({02/22/2002 12:00:00}) ' var_Items.CellCaption(h,1) = {03/14/2002 13:00:00} oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = #3/14/2002 1:00:00 PM#" h = var_Items.AddItem({03/13/2003}) ' var_Items.CellCaption(h,1) = {04/11/2003 11:00:00} oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = #4/11/2003 11:00:00 AM#" |
388 |
Is there a function to display the number of days between two date including the number of hours
Dim h as N Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Start") oComboBox.Columns.Add("End") ' oComboBox.Columns.Add("Duration").ComputedField = "\"D \" + int(date(%1)-date(%0)) + \" H \" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))" var_Column = oComboBox.Columns.Add("Duration") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `\"D \" + int(date(%1)-date(%0)) + \" H \" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))`" var_Items = oComboBox.Items h = var_Items.AddItem({01/11/2001}) ' var_Items.CellCaption(h,1) = {01/14/2001 23:00:00} oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = #1/14/2001 11:00:00 PM#" h = var_Items.AddItem({02/22/2002 12:00:00}) ' var_Items.CellCaption(h,1) = {03/14/2002 13:00:00} oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = #3/14/2002 1:00:00 PM#" h = var_Items.AddItem({03/13/2003}) ' var_Items.CellCaption(h,1) = {04/11/2003 11:00:00} oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = #4/11/2003 11:00:00 AM#" |
387 |
How can I display the number of days between two dates
Dim h as N Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Start") oComboBox.Columns.Add("End") ' oComboBox.Columns.Add("Duration").ComputedField = "(date(%1)-date(%0)) + ' days'" var_Column = oComboBox.Columns.Add("Duration") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `(date(%1)-date(%0)) + ' days'`" var_Items = oComboBox.Items h = var_Items.AddItem({01/11/2001}) ' var_Items.CellCaption(h,1) = {01/14/2001} oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = #1/14/2001#" h = var_Items.AddItem({02/22/2002}) ' var_Items.CellCaption(h,1) = {03/14/2002} oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = #3/14/2002#" h = var_Items.AddItem({03/13/2003}) ' var_Items.CellCaption(h,1) = {04/11/2003} oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = #4/11/2003#" |
386 |
How can I get second part of the date
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Date") ' oComboBox.Columns.Add("Second").ComputedField = "sec(date(%0))" var_Column = oComboBox.Columns.Add("Second") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `sec(date(%0))`" var_Items = oComboBox.Items var_Items.AddItem({01/11/2001 10:10:00}) var_Items.AddItem({02/22/2002 11:01:22}) var_Items.AddItem({03/13/2003 12:23:01}) var_Items.AddItem({04/14/2004 13:11:59}) |
385 |
How can I get minute part of the date
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Date") ' oComboBox.Columns.Add("Minute").ComputedField = "min(date(%0))" var_Column = oComboBox.Columns.Add("Minute") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `min(date(%0))`" var_Items = oComboBox.Items var_Items.AddItem({01/11/2001 10:10:00}) var_Items.AddItem({02/22/2002 11:01:00}) var_Items.AddItem({03/13/2003 12:23:00}) var_Items.AddItem({04/14/2004 13:11:00}) |
384 |
How can I check the hour part only so I know it was afternoon
Dim oComboBox as P Dim var_Column as local Dim var_ConditionalFormat as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.ConditionalFormats.Add("hour(%0)>=12").Bold = .t. var_ConditionalFormat = oComboBox.ConditionalFormats.Add("hour(%0)>=12") oComboBox.TemplateDef = "dim var_ConditionalFormat" oComboBox.TemplateDef = var_ConditionalFormat oComboBox.Template = "var_ConditionalFormat.Bold = True" oComboBox.Columns.Add("Date") ' oComboBox.Columns.Add("Hour").ComputedField = "hour(%0)" var_Column = oComboBox.Columns.Add("Hour") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `hour(%0)`" var_Items = oComboBox.Items var_Items.AddItem({01/11/2001 10:00:00}) var_Items.AddItem({02/22/2002 11:00:00}) var_Items.AddItem({03/13/2003 12:00:00}) var_Items.AddItem({04/14/2004 13:00:00}) |
383 |
What about a function to get the day in the week, or days since Sunday
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Date") ' oComboBox.Columns.Add("WeekDay").ComputedField = "weekday(%0)" var_Column = oComboBox.Columns.Add("WeekDay") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `weekday(%0)`" var_Items = oComboBox.Items var_Items.AddItem({01/11/2001 10:00:00}) var_Items.AddItem({02/22/2002 11:00:00}) var_Items.AddItem({03/13/2003 12:00:00}) var_Items.AddItem({04/14/2004 13:00:00}) |
382 |
Is there any function to get the day of the year or number of days since January 1st
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Date") ' oComboBox.Columns.Add("Day since January 1st").ComputedField = "yearday(%0)" var_Column = oComboBox.Columns.Add("Day since January 1st") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `yearday(%0)`" var_Items = oComboBox.Items var_Items.AddItem({01/11/2001 10:00:00}) var_Items.AddItem({02/22/2002 11:00:00}) var_Items.AddItem({03/13/2003 12:00:00}) var_Items.AddItem({04/14/2004 13:00:00}) |
381 |
How can I display only the day of the date
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Date") ' oComboBox.Columns.Add("Day").ComputedField = "day(%0)" var_Column = oComboBox.Columns.Add("Day") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `day(%0)`" var_Items = oComboBox.Items var_Items.AddItem({01/11/2001 10:00:00}) var_Items.AddItem({02/22/2002 11:00:00}) var_Items.AddItem({03/13/2003 12:00:00}) var_Items.AddItem({04/14/2004 13:00:00}) |
380 |
How can I display only the month of the date
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Date") ' oComboBox.Columns.Add("Month").ComputedField = "month(%0)" var_Column = oComboBox.Columns.Add("Month") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `month(%0)`" var_Items = oComboBox.Items var_Items.AddItem({01/01/2001 10:00:00}) var_Items.AddItem({02/02/2002 11:00:00}) var_Items.AddItem({03/03/2003 12:00:00}) var_Items.AddItem({04/04/2004 13:00:00}) |
379 |
How can I get only the year part from a date expression
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Date") ' oComboBox.Columns.Add("Year").ComputedField = "year(%0)" var_Column = oComboBox.Columns.Add("Year") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `year(%0)`" var_Items = oComboBox.Items var_Items.AddItem({01/01/2001 10:00:00}) var_Items.AddItem({02/02/2002 11:00:00}) var_Items.AddItem({03/03/2003 12:00:00}) var_Items.AddItem({04/04/2004 13:00:00}) |
378 |
Can I convert the expression to date
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Number") ' oComboBox.Columns.Add("Date").ComputedField = "date(dbl(%0))" var_Column = oComboBox.Columns.Add("Date") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `date(dbl(%0))`" var_Items = oComboBox.Items var_Items.AddItem("-1.98") var_Items.AddItem("30000.99") var_Items.AddItem("3561.23") var_Items.AddItem("1232.34") |
377 |
Can I convert the expression to a number, double or float
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Number") ' oComboBox.Columns.Add("Number + 2").ComputedField = "dbl(%0)+2" var_Column = oComboBox.Columns.Add("Number + 2") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `dbl(%0)+2`" var_Items = oComboBox.Items var_Items.AddItem("-1.98") var_Items.AddItem("0.99") var_Items.AddItem("1.23") var_Items.AddItem("2.34") |
376 |
How can I display dates in long format
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Date") ' oComboBox.Columns.Add("LongFormat").ComputedField = "longdate(%0)" var_Column = oComboBox.Columns.Add("LongFormat") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `longdate(%0)`" var_Items = oComboBox.Items var_Items.AddItem({01/01/2001 10:00:00}) var_Items.AddItem({02/02/2002 11:00:00}) var_Items.AddItem({03/03/2003 12:00:00}) var_Items.AddItem({04/04/2004 13:00:00}) |
375 |
How can I display dates in short format
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Date") ' oComboBox.Columns.Add("ShortFormat").ComputedField = "shortdate(%0)" var_Column = oComboBox.Columns.Add("ShortFormat") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `shortdate(%0)`" var_Items = oComboBox.Items var_Items.AddItem({01/01/2001 10:00:00}) var_Items.AddItem({02/02/2002 11:00:00}) var_Items.AddItem({03/03/2003 12:00:00}) var_Items.AddItem({04/04/2004 13:00:00}) |
374 |
How can I display the time only of a date expression
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Date") ' oComboBox.Columns.Add("Time").ComputedField = "'time is:' + time(date(%0))" var_Column = oComboBox.Columns.Add("Time") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `'time is:' + time(date(%0))`" var_Items = oComboBox.Items var_Items.AddItem({01/01/2001 10:00:00}) var_Items.AddItem({02/02/2002 11:00:00}) var_Items.AddItem({03/03/2003 12:00:00}) var_Items.AddItem({04/04/2004 13:00:00}) |
373 |
Is there any function to display currencies, or money formatted as in the control panel
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Number") ' oComboBox.Columns.Add("Currency").ComputedField = "currency(dbl(%0))" var_Column = oComboBox.Columns.Add("Currency") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `currency(dbl(%0))`" var_Items = oComboBox.Items var_Items.AddItem("1.23") var_Items.AddItem("2.34") var_Items.AddItem("10000.99") |
372 |
How can I convert the expression to a string so I can look into the date string expression for month's name
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Number") ' oComboBox.Columns.Add("Str").ComputedField = "str(%0) + ' AA'" var_Column = oComboBox.Columns.Add("Str") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `str(%0) + ' AA'`" var_Items = oComboBox.Items var_Items.AddItem("-1.98") var_Items.AddItem("0.99") var_Items.AddItem("1.23") var_Items.AddItem("2.34") |
371 |
Can I display the absolute value or positive part of the number
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Number") ' oComboBox.Columns.Add("Abs").ComputedField = "abs(%0)" var_Column = oComboBox.Columns.Add("Abs") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `abs(%0)`" var_Items = oComboBox.Items var_Items.AddItem("-1.98") var_Items.AddItem("0.99") var_Items.AddItem("1.23") var_Items.AddItem("2.34") |
370 |
Is there any function to get largest number with no fraction part that is not greater than the value
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Number") ' oComboBox.Columns.Add("Floor").ComputedField = "floor(%0)" var_Column = oComboBox.Columns.Add("Floor") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `floor(%0)`" var_Items = oComboBox.Items var_Items.AddItem("-1.98") var_Items.AddItem("0.99") var_Items.AddItem("1.23") var_Items.AddItem("2.34") |
369 |
Is there any function to round the values base on the .5 value
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Number") ' oComboBox.Columns.Add("Round").ComputedField = "round(%0)" var_Column = oComboBox.Columns.Add("Round") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `round(%0)`" var_Items = oComboBox.Items var_Items.AddItem("-1.98") var_Items.AddItem("0.99") var_Items.AddItem("1.23") var_Items.AddItem("2.34") |
368 |
How can I get or display the integer part of the cell
Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Number") ' oComboBox.Columns.Add("Int").ComputedField = "int(%0)" var_Column = oComboBox.Columns.Add("Int") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `int(%0)`" var_Items = oComboBox.Items var_Items.AddItem("-1.98") var_Items.AddItem("0.99") var_Items.AddItem("1.23") var_Items.AddItem("2.34") |
367 |
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
Dim h as N Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.Columns.Add("").ComputedField = "proper(%0)" var_Column = oComboBox.Columns.Add("") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `proper(%0)`" var_Items = oComboBox.Items h = var_Items.AddItem("root") var_Items.InsertItem(h,,"child child") var_Items.InsertItem(h,,"child child") var_Items.InsertItem(h,,"child child") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
366 |
Is there any option to display cells in uppercase
Dim h as N Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.Columns.Add("").ComputedField = "upper(%0)" var_Column = oComboBox.Columns.Add("") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `upper(%0)`" var_Items = oComboBox.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.InsertItem(h,,"Chld 3") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
365 |
Is there any option to display cells in lowercase
Dim h as N Dim oComboBox as P Dim var_Column as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.Columns.Add("").ComputedField = "lower(%0)" var_Column = oComboBox.Columns.Add("") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ComputedField = `lower(%0)`" var_Items = oComboBox.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.InsertItem(h,,"Chld 3") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
364 |
How can I mark the cells that has a specified type, ie strings only
Dim h as N Dim oComboBox as P Dim var_ConditionalFormat as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.ConditionalFormats.Add("type(%0) = 8").ForeColor = 255 var_ConditionalFormat = oComboBox.ConditionalFormats.Add("type(%0) = 8") oComboBox.TemplateDef = "dim var_ConditionalFormat" oComboBox.TemplateDef = var_ConditionalFormat oComboBox.Template = "var_ConditionalFormat.ForeColor = 255" oComboBox.Columns.Add("") var_Items = oComboBox.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,2) var_Items.InsertItem(h,,"Chld 3") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
363 |
How can I bold the items that contains data or those who displays empty strings
Dim h as N Dim hC as N Dim oComboBox as P Dim var_ConditionalFormat as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.ConditionalFormats.Add("not len(%1)=0").Bold = .t. var_ConditionalFormat = oComboBox.ConditionalFormats.Add("not len(%1)=0") oComboBox.TemplateDef = "dim var_ConditionalFormat" oComboBox.TemplateDef = var_ConditionalFormat oComboBox.Template = "var_ConditionalFormat.Bold = True" oComboBox.Columns.Add("C1") oComboBox.Columns.Add("C2") var_Items = oComboBox.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") hC = var_Items.InsertItem(h,,"Child 2") ' var_Items.CellCaption(hC,1) = "1" oComboBox.TemplateDef = "dim var_Items,hC" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = hC oComboBox.Template = "var_Items.CellCaption(hC,1) = `1`" var_Items.InsertItem(h,,"Child 3") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
362 |
Can I change the background color for items or cells that contains a specified string
Dim h as N Dim oComboBox as P Dim var_ConditionalFormat as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.ConditionalFormats.Add("%0 contains 'hi'").BackColor = 255 var_ConditionalFormat = oComboBox.ConditionalFormats.Add("%0 contains 'hi'") oComboBox.TemplateDef = "dim var_ConditionalFormat" oComboBox.TemplateDef = var_ConditionalFormat oComboBox.Template = "var_ConditionalFormat.BackColor = 255" oComboBox.Columns.Add("") var_Items = oComboBox.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.InsertItem(h,,"Chld 3") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
361 |
Is there any option to change the fore color for cells or items that ends with a specified string
Dim h as N Dim oComboBox as P Dim var_ConditionalFormat as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.ConditionalFormats.Add("%0 endwith '22'").ForeColor = 255 var_ConditionalFormat = oComboBox.ConditionalFormats.Add("%0 endwith '22'") oComboBox.TemplateDef = "dim var_ConditionalFormat" oComboBox.TemplateDef = var_ConditionalFormat oComboBox.Template = "var_ConditionalFormat.ForeColor = 255" oComboBox.Columns.Add("") var_Items = oComboBox.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 1.22") var_Items.InsertItem(h,,"Child 2.22") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
360 |
How can I highlight the cells or items that starts with a specified string
Dim h as N Dim oComboBox as P Dim var_ConditionalFormat as local Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.ConditionalFormats.Add("%0 startwith 'C'").Underline = .t. var_ConditionalFormat = oComboBox.ConditionalFormats.Add("%0 startwith 'C'") oComboBox.TemplateDef = "dim var_ConditionalFormat" oComboBox.TemplateDef = var_ConditionalFormat oComboBox.Template = "var_ConditionalFormat.Underline = True" oComboBox.Columns.Add("") var_Items = oComboBox.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.InsertItem(h,,"SChild 3") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
359 |
How can I change the background color or the visual appearance using ebn for a particular column
Dim oComboBox as P Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") var_Columns = oComboBox.Columns var_Columns.Add("Column 1") ' var_Columns.Add("Column 2").Def(7) = 16777216 var_Column = var_Columns.Add("Column 2") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.Def(7) = 16777216" ' var_Columns.Add("Column 3").Def(7) = 16777471 var_Column1 = var_Columns.Add("Column 3") oComboBox.TemplateDef = "dim var_Column1" oComboBox.TemplateDef = var_Column1 oComboBox.Template = "var_Column1.Def(7) = 16777471" var_Columns.Add("Column 4") |
358 |
How can I change the background color for a particular column
Dim oComboBox as P Dim var_Column as local Dim var_Columns as P oComboBox = topparent:CONTROL_ACTIVEX1.activex var_Columns = oComboBox.Columns var_Columns.Add("Column 1") ' var_Columns.Add("Column 2").Def(7) = 8439039 var_Column = var_Columns.Add("Column 2") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.Def(7) = 8439039" var_Columns.Add("Column 3") |
357 |
Does your control support prompt feature
Dim oComboBox as P Dim var_Column as local oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") oComboBox.AutoComplete = .f. ' oComboBox.Columns.Add("Column 1").Prompt = "<img>1</img><i><fgcolor=808080>type to search</fgcolor></i>" var_Column = oComboBox.Columns.Add("Column 1") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.Prompt = `<img>1</img><i><fgcolor=808080>type to search</fgcolor></i>`" oComboBox.Items.AddItem(0) oComboBox.Items.AddItem(1) oComboBox.Items.AddItem(2) |
356 |
How can I display the column's header using multiple lines
Dim oComboBox as P Dim var_Column as local oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.HeaderHeight = 128 oComboBox.HeaderSingleLine = .f. ' oComboBox.Columns.Add("This is just a column that should break the header.").Width = 32 var_Column = oComboBox.Columns.Add("This is just a column that should break the header.") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.Width = 32" oComboBox.Columns.Add("This is just another column that should break the header.") |
355 |
How can I sort the value gets listed in the drop down filter window
Dim h as N Dim oComboBox as P Dim var_Column as P Dim var_Column1 as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.LinesAtRoot = -1 oComboBox.MarkSearchColumn = .f. oComboBox.Template = "Description(0) = ``" // oComboBox.Description(0) = "" oComboBox.Template = "Description(1) = ``" // oComboBox.Description(1) = "" oComboBox.Template = "Description(2) = ``" // oComboBox.Description(2) = "" var_Column = oComboBox.Columns.Add("P1") var_Column.DisplayFilterButton = .t. var_Column.DisplayFilterPattern = .f. var_Column.FilterList = 16 var_Column1 = oComboBox.Columns.Add("P2") var_Column1.DisplayFilterButton = .t. var_Column1.DisplayFilterPattern = .f. var_Column1.FilterList = 32 var_Items = oComboBox.Items h = var_Items.AddItem("Z3") ' var_Items.CellCaption(h,1) = "C" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `C`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Z1"),1) = "B" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Z1`),1) = `B`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Z2"),1) = "A" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Z2`),1) = `A`" ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
354 |
Is there any property to disable the popup/context menu being shown when the user does a right click in the control's label area
Dim oComboBox as P Dim var_Column as local oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.Columns.Add("Default").AllowEditContextMenu = .f. var_Column = oComboBox.Columns.Add("Default") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.AllowEditContextMenu = False" oComboBox.Items.AddItem(0) oComboBox.Items.AddItem(1) oComboBox.Items.AddItem(2) |
353 |
How can I align the text/caption on the scroll bar
|
352 |
Does you control support RTL languages or if there is a property RightToLeft
Dim oComboBox as P Dim var_Column as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.RightToLeft = .t. oComboBox.ItemsAllowSizing = -1 oComboBox.DrawGridLines = 1 oComboBox.LinesAtRoot = -1 oComboBox.ScrollBySingleLine = .t. oComboBox.DefaultItemHeight = 64 var_Column = oComboBox.Columns.Add("Column") var_Column.Alignment = 2 var_Column.HeaderAlignment = 2 var_Column.EditAlignment = 2 var_Items = oComboBox.Items var_Items.AddItem("Item 1") ' var_Items.ItemHeight(var_Items.InsertItem(var_Items.AddItem("Parent"),,"Item 2")) = 48 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.ItemHeight(InsertItem(AddItem(`Parent`),,`Item 2`)) = 48" var_Items.AddItem("Item 3") ' var_Items.ExpandItem(var_Items.ItemByIndex(1)) = .t. oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.ExpandItem(ItemByIndex(1)) = True" |
351 |
How do I enable resizing all the items at runtime
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.ItemsAllowSizing = 1 oComboBox.DrawGridLines = 1 oComboBox.Columns.Add("Column") oComboBox.Items.AddItem("Item 1") var_Items = oComboBox.Items ' var_Items.ItemHeight(var_Items.AddItem("Item 2")) = 48 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.ItemHeight(AddItem(`Item 2`)) = 48" oComboBox.Items.AddItem("Item 3") |
350 |
How can I remove the filter
Dim oComboBox as P Dim var_Column as P oComboBox = topparent:CONTROL_ACTIVEX1.activex var_Column = oComboBox.Columns.Add("Column") var_Column.DisplayFilterButton = .t. var_Column.FilterType = 1 oComboBox.ApplyFilter() oComboBox.ClearFilter() |
349 |
How do I display the icons being selected in the control's label
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") oComboBox.Columns.Add("Column") var_Items = oComboBox.Items ' var_Items.CellImage(var_Items.AddItem("Image 1"),0) = 1 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellImage(AddItem(`Image 1`),0) = 1" ' var_Items.CellImage(var_Items.AddItem("Image 2"),0) = 2 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellImage(AddItem(`Image 2`),0) = 2" ' var_Items.CellImage(var_Items.AddItem("Image 3"),0) = 3 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellImage(AddItem(`Image 3`),0) = 3" oComboBox.Template = "AssignEditImageOnSelect(0) = True" // oComboBox.AssignEditImageOnSelect(0) = .t. oComboBox.Value = "Image 2" |
348 |
How do I select a value
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.IntegralHeight = .t. oComboBox.LinesAtRoot = 1 oComboBox.TreeColumnIndex = 1 oComboBox.Columns.Add("Column 1") oComboBox.Columns.Add("Column 2") var_Items = oComboBox.Items h = var_Items.AddItem("Root 1.1") ' var_Items.CellCaption(h,1) = "Root 1.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 2.1`),1) = `Child 2.2`" ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("Root 2.1") ' var_Items.CellCaption(h,1) = "Root 2.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 2.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" oComboBox.Value = "Root 1.1" |
347 |
How do I select a value
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.IntegralHeight = .t. oComboBox.LinesAtRoot = 1 oComboBox.TreeColumnIndex = 1 oComboBox.Columns.Add("Column 1") oComboBox.Columns.Add("Column 2") var_Items = oComboBox.Items h = var_Items.AddItem("Root 1.1") ' var_Items.CellCaption(h,1) = "Root 1.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 2.1`),1) = `Child 2.2`" ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("Root 2.1") ' var_Items.CellCaption(h,1) = "Root 2.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 2.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" oComboBox.Template = "Select(1) = `Root 1.2`" // oComboBox.Select(1) = "Root 1.2" |
346 |
How do change the visual appearance for the drop down border, using EBN
Dim oComboBox as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") oComboBox.DropDownBorder = 16777216 '1000000 + |
345 |
How do I remove the drop down's border
Dim oComboBox as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.DropDownBorder = 0 |
344 |
How can I change the foreground color for edit controls
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.ForeColorEdit = 255 oComboBox.IntegralHeight = .t. oComboBox.LinesAtRoot = 1 oComboBox.TreeColumnIndex = 1 oComboBox.Columns.Add("Column 1") oComboBox.Columns.Add("Column 2") var_Items = oComboBox.Items h = var_Items.AddItem("Root 1.1") ' var_Items.CellCaption(h,1) = "Root 1.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 2.1`),1) = `Child 2.2`" ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("Root 2.1") ' var_Items.CellCaption(h,1) = "Root 2.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 2.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" oComboBox.Template = "Select(0) = `Root 1.1`" // oComboBox.Select(0) = "Root 1.1" |
343 |
How can I change the background color for edit controls
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.BackColorEdit = 255 oComboBox.IntegralHeight = .t. oComboBox.LinesAtRoot = 1 oComboBox.TreeColumnIndex = 1 oComboBox.Columns.Add("Column 1") oComboBox.Columns.Add("Column 2") var_Items = oComboBox.Items h = var_Items.AddItem("Root 1.1") ' var_Items.CellCaption(h,1) = "Root 1.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 2.1`),1) = `Child 2.2`" ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("Root 2.1") ' var_Items.CellCaption(h,1) = "Root 2.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 2.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" oComboBox.Template = "Select(0) = `Root 1.1`" // oComboBox.Select(0) = "Root 1.1" |
342 |
How can I hide the drop down buttons when the control loses the focus
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.HideDropDownButton = .t. oComboBox.IntegralHeight = .t. oComboBox.LinesAtRoot = 1 oComboBox.TreeColumnIndex = 1 oComboBox.Columns.Add("Column 1") oComboBox.Columns.Add("Column 2") var_Items = oComboBox.Items h = var_Items.AddItem("Root 1.1") ' var_Items.CellCaption(h,1) = "Root 1.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 2.1`),1) = `Child 2.2`" ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("Root 2.1") ' var_Items.CellCaption(h,1) = "Root 2.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 2.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" |
341 |
How can I ensure that the drop down portions doesn't show partial items
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.IntegralHeight = .t. oComboBox.LinesAtRoot = 1 oComboBox.TreeColumnIndex = 1 oComboBox.Columns.Add("Column 1") oComboBox.Columns.Add("Column 2") var_Items = oComboBox.Items h = var_Items.AddItem("Root 1.1") ' var_Items.CellCaption(h,1) = "Root 1.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 2.1`),1) = `Child 2.2`" ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("Root 2.1") ' var_Items.CellCaption(h,1) = "Root 2.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 2.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" |
340 |
How can I close the drop down window when user double clicks it
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.CloseOnDblClk = .t. oComboBox.LinesAtRoot = 1 oComboBox.TreeColumnIndex = 1 oComboBox.Columns.Add("Column 1") oComboBox.Columns.Add("Column 2") var_Items = oComboBox.Items h = var_Items.AddItem("Root 1.1") ' var_Items.CellCaption(h,1) = "Root 1.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 2.1`),1) = `Child 2.2`" ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("Root 2.1") ' var_Items.CellCaption(h,1) = "Root 2.2" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `Root 2.2`" ' var_Items.CellCaption(var_Items.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Child 1.1`),1) = `Child 1.2`" |
339 |
How do I get the handle of the drop down window
Dim oComboBox as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add(oComboBox.hWndDropDown) |
338 |
How do I specify the height of the control's label
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.LabelHeight = 34 oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
337 |
The control selects the portion of text that doesn't match with the selected item. How can I avoid that
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.AutoSelect = .f. oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
336 |
How can I show the drop down window as soon as user starts typing in the control
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.AutoDropDown = .t. oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
335 |
How do I change the text in the edit or label area
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") oComboBox.Template = "EditText(0) = `Test`" // oComboBox.EditText(0) = "Test" |
334 |
How do I lock or make read-only the control
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Locked = .t. oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
333 |
How do I let user to resize only the height of the drop down window, at runtime
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.AllowSizeGrip = .t. oComboBox.AllowHResize = .f. oComboBox.MinWidthList = 100 oComboBox.MinHeightList = 100 oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
332 |
How do I let user to resize only the width of the drop down window, at runtime
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.AllowSizeGrip = .t. oComboBox.AllowVResize = .f. oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
331 |
How do I let user to resize the drop down window, at runtime
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.AllowSizeGrip = .t. oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
330 |
How do I specify the height of the drop down window
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Template = "HeightList() = 400" // oComboBox.HeightList() = 400 oComboBox.MinWidthList = 100 oComboBox.AllowSizeGrip = .t. oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
329 |
How do I specify the minimum height of the drop down window
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.MinHeightList = 100 oComboBox.AllowSizeGrip = .t. oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
328 |
How do I specify the width of the drop down window
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Template = "WidthList() = 100" // oComboBox.WidthList() = 100 oComboBox.AllowSizeGrip = .t. oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
327 |
How do I specify the minimum width of the drop down window
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.MinWidthList = 100 oComboBox.AllowSizeGrip = .t. oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
326 |
I have multiple columns, how can I display a single edit in the control's label
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.SingleEdit = .t. oComboBox.Columns.Add("Column 1") oComboBox.Columns.Add("Column 2") var_Items = oComboBox.Items ' var_Items.CellCaption(var_Items.AddItem("Item 1"),1) = "SubItem 1" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(AddItem(`Item 1`),1) = `SubItem 1`" ' var_Items.CellCaption(var_Items.AddItem("Item 2"),1) = "SubItem 2" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(AddItem(`Item 2`),1) = `SubItem 2`" ' var_Items.CellCaption(var_Items.AddItem("Item 3"),1) = "SubItem 3" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(AddItem(`Item 3`),1) = `SubItem 3`" |
325 |
How do I turn off the auto complete feature
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.AutoComplete = .f. oComboBox.Columns.Add("Column") var_Items = oComboBox.Items var_Items.AddItem("Item 3") var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") |
324 |
The control supports three styles: Simple, DropDown and DropDownList. How can I change the style
Dim oComboBox as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Style = 2 |
323 |
Is there any option to align the header to the left and the data to the right
Dim oComboBox as P Dim var_Column as local Dim var_Column1 as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex ' oComboBox.Columns.Add("Left").Alignment = 0 var_Column = oComboBox.Columns.Add("Left") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.Alignment = 0" var_Column1 = oComboBox.Columns.Add("Right") var_Column1.Alignment = 2 var_Column1.HeaderAlignment = 2 var_Column1.EditAlignment = 2 var_Items = oComboBox.Items ' var_Items.CellCaption(var_Items.AddItem("left"),1) = "right" oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(AddItem(`left`),1) = `right`" |
322 |
How do I change the control's border, using your EBN files
Dim oComboBox as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") oComboBox.Appearance = 16777216 '1000000 + |
321 |
Can I change the default border of the tooltip, using your EBN files
Dim oComboBox as P Dim var_Column as local oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.ToolTipDelay = 1 oComboBox.ToolTipWidth = 364 oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") oComboBox.Template = "Background(64) = 16777216" // oComboBox.Background(64) = 16777216 ' oComboBox.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column" var_Column = oComboBox.Columns.Add("tootip") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ToolTip = `this is a tooltip assigned to a column`" |
320 |
Can I change the background color for the tooltip
Dim oComboBox as P Dim var_Column as local oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.ToolTipDelay = 1 oComboBox.ToolTipWidth = 364 oComboBox.Template = "Background(65) = 255" // oComboBox.Background(65) = 255 ' oComboBox.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column" var_Column = oComboBox.Columns.Add("tootip") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ToolTip = `this is a tooltip assigned to a column`" |
319 |
Does the tooltip support HTML format
Dim oComboBox as P Dim var_Column as local oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.ToolTipDelay = 1 oComboBox.ToolTipWidth = 364 ' oComboBox.Columns.Add("tootip").ToolTip = "<font Tahoma;11>T</font>his is an HTML <b>tooltip</b> assigned to a <fgcolor=FF0000>column</fgcolor>" var_Column = oComboBox.Columns.Add("tootip") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ToolTip = `<font Tahoma;11>T</font>his is an HTML <b>tooltip</b> assigned to a <fgcolor=FF0000>column</fgcolor>`" |
318 |
Can I change the forecolor for the tooltip
Dim oComboBox as P Dim var_Column as local oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.ToolTipDelay = 1 oComboBox.ToolTipWidth = 364 oComboBox.Template = "Background(66) = 255" // oComboBox.Background(66) = 255 ' oComboBox.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column" var_Column = oComboBox.Columns.Add("tootip") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ToolTip = `this is a tooltip assigned to a column`" |
317 |
Can I change the foreground color for the tooltip
Dim oComboBox as P Dim var_Column as local oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.ToolTipDelay = 1 oComboBox.ToolTipWidth = 364 ' oComboBox.Columns.Add("tootip").ToolTip = "<fgcolor=FF0000>this is a tooltip assigned to a column</fgcolor>" var_Column = oComboBox.Columns.Add("tootip") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.ToolTip = `<fgcolor=FF0000>this is a tooltip assigned to a column</fgcolor>`" |
316 |
How can I merge cells
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.DrawGridLines = -1 oComboBox.MarkSearchColumn = .f. oComboBox.Columns.Add("C1") oComboBox.Columns.Add("C2") oComboBox.Columns.Add("C3") var_Items = oComboBox.Items h = var_Items.AddItem("this cell merges the first two columns") ' var_Items.CellMerge(h,0) = 1 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellMerge(h,0) = 1" h = var_Items.AddItem() ' var_Items.CellCaption(h,1) = "this cell merges the last two columns" oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `this cell merges the last two columns`" ' var_Items.CellMerge(h,1) = 2 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellMerge(h,1) = 2" h = var_Items.AddItem("this cell merges the all three columns") ' var_Items.CellMerge(h,0) = 1 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellMerge(h,0) = 1" ' var_Items.CellMerge(h,0) = 2 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellMerge(h,0) = 2" h = var_Items.AddItem("this draws a divider item") ' var_Items.ItemDivider(h) = 0 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDivider(h) = 0" |
315 |
How can I merge cells
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.MarkSearchColumn = .f. oComboBox.TreeColumnIndex = -1 oComboBox.Columns.Add("C1") oComboBox.Columns.Add("C2") var_Items = oComboBox.Items h = var_Items.AddItem("Cell 1") ' var_Items.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.`" ' var_Items.CellSingleLine(h,1) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellSingleLine(h,1) = False" h = var_Items.AddItem("This is bit of text merges all cells in the item") ' var_Items.ItemDivider(h) = 0 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDivider(h) = 0" ' var_Items.CellHAlignment(h,0) = 1 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellHAlignment(h,0) = 1" |
314 |
How can I change the color for separator / dividers items
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.MarkSearchColumn = .f. oComboBox.TreeColumnIndex = -1 oComboBox.ScrollBySingleLine = .f. oComboBox.Columns.Add("C1") oComboBox.Columns.Add("C2") var_Items = oComboBox.Items h = var_Items.AddItem("Cell 1") ' var_Items.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.`" ' var_Items.CellSingleLine(h,1) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellSingleLine(h,1) = False" h = var_Items.AddItem() ' var_Items.ItemDivider(h) = 0 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDivider(h) = 0" ' var_Items.ItemDividerLine(h) = 4 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDividerLine(h) = 4" ' var_Items.ItemDividerLineAlignment(h) = 1 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDividerLineAlignment(h) = 1" ' var_Items.ItemHeight(h) = 6 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemHeight(h) = 6" ' var_Items.SelectableItem(h) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.SelectableItem(h) = False" h = var_Items.AddItem("Cell 2") ' var_Items.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.`" ' var_Items.CellSingleLine(h,1) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellSingleLine(h,1) = False" |
313 |
How can I add separator - dividers items
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.MarkSearchColumn = .f. oComboBox.TreeColumnIndex = -1 oComboBox.ScrollBySingleLine = .f. oComboBox.Columns.Add("C1") oComboBox.Columns.Add("C2") var_Items = oComboBox.Items h = var_Items.AddItem("Cell 1") ' var_Items.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.`" ' var_Items.CellSingleLine(h,1) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellSingleLine(h,1) = False" h = var_Items.AddItem() ' var_Items.ItemDivider(h) = 0 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDivider(h) = 0" ' var_Items.ItemDividerLine(h) = 4 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDividerLine(h) = 4" ' var_Items.ItemDividerLineAlignment(h) = 1 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDividerLineAlignment(h) = 1" ' var_Items.ItemHeight(h) = 6 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemHeight(h) = 6" ' var_Items.SelectableItem(h) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.SelectableItem(h) = False" h = var_Items.AddItem("Cell 2") ' var_Items.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.`" ' var_Items.CellSingleLine(h,1) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellSingleLine(h,1) = False" |
312 |
Can I change the style of the line being displayed by a divider item
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.MarkSearchColumn = .f. oComboBox.TreeColumnIndex = -1 oComboBox.ScrollBySingleLine = .f. oComboBox.Columns.Add("C1") oComboBox.Columns.Add("C2") var_Items = oComboBox.Items h = var_Items.AddItem("Cell 1") ' var_Items.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.`" ' var_Items.CellSingleLine(h,1) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellSingleLine(h,1) = False" h = var_Items.AddItem("This is bit of text that's displayed on the entire item, divider.") ' var_Items.ItemDivider(h) = 0 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDivider(h) = 0" ' var_Items.ItemDividerLine(h) = 4 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDividerLine(h) = 4" ' var_Items.CellHAlignment(h,0) = 1 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellHAlignment(h,0) = 1" ' var_Items.ItemHeight(h) = 24 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemHeight(h) = 24" |
311 |
Can I remove the line being displayed by a divider item
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.MarkSearchColumn = .f. oComboBox.TreeColumnIndex = -1 oComboBox.Columns.Add("C1") oComboBox.Columns.Add("C2") var_Items = oComboBox.Items h = var_Items.AddItem("Cell 1") ' var_Items.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.`" ' var_Items.CellSingleLine(h,1) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellSingleLine(h,1) = False" h = var_Items.AddItem("This is bit of text that's displayed on the entire item, divider.") ' var_Items.ItemDivider(h) = 0 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDivider(h) = 0" ' var_Items.ItemDividerLine(h) = 0 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDividerLine(h) = 0" ' var_Items.CellHAlignment(h,0) = 1 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellHAlignment(h,0) = 1" |
310 |
How can I display a divider item, merging all cells
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.MarkSearchColumn = .f. oComboBox.TreeColumnIndex = -1 oComboBox.Columns.Add("C1") oComboBox.Columns.Add("C2") var_Items = oComboBox.Items h = var_Items.AddItem("Cell 1") ' var_Items.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.`" ' var_Items.CellSingleLine(h,1) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellSingleLine(h,1) = False" h = var_Items.AddItem("This is bit of text that's displayed on the entire item, divider.") ' var_Items.ItemDivider(h) = 0 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemDivider(h) = 0" ' var_Items.CellHAlignment(h,0) = 1 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellHAlignment(h,0) = 1" |
309 |
How can I fix or lock items
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Default") var_Items = oComboBox.Items ' var_Items.LockedItemCount(0) = 1 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.LockedItemCount(0) = 1" ' var_Items.CellCaption(var_Items.LockedItem(0,0),0) = "This is a locked item, fixed to the top side of the control." oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(LockedItem(0,0),0) = `This is a locked item, fixed to the top side of the control.`" ' var_Items.ItemBackColor(var_Items.LockedItem(0,0)) = 12240068 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.ItemBackColor(LockedItem(0,0)) = 12240068" ' var_Items.LockedItemCount(2) = 2 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.LockedItemCount(2) = 2" ' var_Items.CellCaption(var_Items.LockedItem(2,0),0) = "This is a locked item, fixed to the top side of the control." oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(LockedItem(2,0),0) = `This is a locked item, fixed to the top side of the control.`" ' var_Items.ItemBackColor(var_Items.LockedItem(2,0)) = 12240068 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.ItemBackColor(LockedItem(2,0)) = 12240068" ' var_Items.CellCaption(var_Items.LockedItem(2,1),0) = "This is a locked item, fixed to the top side of the control." oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(LockedItem(2,1),0) = `This is a locked item, fixed to the top side of the control.`" ' var_Items.ItemBackColor(var_Items.LockedItem(2,1)) = 12237498 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.ItemBackColor(LockedItem(2,1)) = 12237498" |
308 |
How can I fix or lock an item on the bottom side of the control
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Default") var_Items = oComboBox.Items ' var_Items.LockedItemCount(2) = 1 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.LockedItemCount(2) = 1" ' var_Items.CellCaption(var_Items.LockedItem(2,0),0) = "This is a locked item, fixed to the bottom side of the control." oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(LockedItem(2,0),0) = `This is a locked item, fixed to the bottom side of the control.`" h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
307 |
How can I fix or lock an item on the top of the control
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Default") var_Items = oComboBox.Items ' var_Items.LockedItemCount(0) = 1 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.LockedItemCount(0) = 1" ' var_Items.CellCaption(var_Items.LockedItem(0,0),0) = "This is a locked item, fixed to the top side of the control." oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaption(LockedItem(0,0),0) = `This is a locked item, fixed to the top side of the control.`" h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ExpandItem(h) = True" |
306 |
Is there any function to limit the height of the items when I display it using multiple lines
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.ScrollBySingleLine = .t. oComboBox.Columns.Add("C1") oComboBox.Columns.Add("C2") var_Items = oComboBox.Items h = var_Items.AddItem("Cell 1") ' var_Items.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaption(h,1) = `This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.`" ' var_Items.CellSingleLine(h,1) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellSingleLine(h,1) = False" ' var_Items.ItemMaxHeight(h) = 48 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.ItemMaxHeight(h) = 48" |
305 |
Why I cannot center my cells in the column
Dim oComboBox as P Dim var_Column as local oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.TreeColumnIndex = -1 oComboBox.DrawGridLines = -2 ' oComboBox.Columns.Add("Default").Alignment = 1 var_Column = oComboBox.Columns.Add("Default") oComboBox.TemplateDef = "dim var_Column" oComboBox.TemplateDef = var_Column oComboBox.Template = "var_Column.Alignment = 1" oComboBox.Items.AddItem("item 1") oComboBox.Items.AddItem("item 2") oComboBox.Items.AddItem("item 3") |
304 |
How can I align the cell to the left, center or to the right
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.TreeColumnIndex = -1 oComboBox.DrawGridLines = -2 oComboBox.Columns.Add("Default") var_Items = oComboBox.Items ' var_Items.CellHAlignment(var_Items.AddItem("left"),0) = 0 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellHAlignment(AddItem(`left`),0) = 0" ' var_Items.CellHAlignment(var_Items.AddItem("center"),0) = 1 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellHAlignment(AddItem(`center`),0) = 1" ' var_Items.CellHAlignment(var_Items.AddItem("right"),0) = 2 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellHAlignment(AddItem(`right`),0) = 2" |
303 |
How do I apply HTML format to a cell
Dim h as N Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.TreeColumnIndex = -1 oComboBox.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") oComboBox.Template = "HTMLPicture(`p1`) = `c:\exontrol\images\zipdisk.gif`" // oComboBox.HTMLPicture("p1") = "c:\exontrol\images\zipdisk.gif" oComboBox.Template = "HTMLPicture(`p2`) = `c:\exontrol\images\auction.gif`" // oComboBox.HTMLPicture("p2") = "c:\exontrol\images\auction.gif" oComboBox.Columns.Add("Default") var_Items = oComboBox.Items h = var_Items.AddItem("The following item shows some of the HTML format supported:") ' var_Items.CellHAlignment(h,0) = 1 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellHAlignment(h,0) = 1" h = var_Items.AddItem("<br>text icons <img>1</img>, <img>2</img>, ... pictures <img>p1</img>, <img>p2</img> <br><br>text <b>bold</b>, <i>italic</i>, <u>underline</u>, <s>strikeout</s>, ...<br><dotline>and so on...<br> <a>anchor</a> or <a2>hyperlink</a><br><fgcolor=FF0000>fgcolor</fgcolor> or <bgcolor=00FF00>bgcolor</bgcolor> ") ' var_Items.CellCaptionFormat(h,0) = 1 oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellCaptionFormat(h,0) = 1" ' var_Items.CellSingleLine(h,0) = .f. oComboBox.TemplateDef = "dim var_Items,h" oComboBox.TemplateDef = var_Items oComboBox.TemplateDef = h oComboBox.Template = "var_Items.CellSingleLine(h,0) = False" |
302 |
How can I change the font for a cell
Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Default") oComboBox.Items.AddItem("std font") var_Items = oComboBox.Items ' var_Items.CellCaptionFormat(var_Items.AddItem("this <font tahoma;12>is a bit of text with</font> a different font"),0) = 1 oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellCaptionFormat(AddItem(`this <font tahoma;12>is a bit of text with</font> a different font`),0) = 1" |
301 |
How can I change the font for a cell
Dim f as P Dim oComboBox as P Dim var_Items as P oComboBox = topparent:CONTROL_ACTIVEX1.activex oComboBox.Columns.Add("Default") oComboBox.Items.AddItem("default font") f = OLE.Create("StdFont") f.Name = "Tahoma" f.Size = 12 var_Items = oComboBox.Items ' var_Items.CellFont(var_Items.AddItem("new font"),0) = f oComboBox.TemplateDef = "dim var_Items" oComboBox.TemplateDef = var_Items oComboBox.Template = "var_Items.CellFont(AddItem(`new font`),0) = f" |